
Oct 24, 2013 1:32:01 AM database.ProductManagerDAO DeleteProductByProductID
SEVERE: null
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row:
a foreign key constraint fails (`onlineshopping`.`receiptitem`, CONSTRAINT `fk_ReceiptItem_Product1` FOREIGN KEY (`Product_idProduct`) REFERENCES `product` (`idProduct`) ON DELETE NO ACTION ON UPDATE NO ACTION)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)


<a id="deleteButton" href="<%= request.getContextPath()%>/Administration/Product/delete-product/<s:property value='idProduct'/>" title="<s:property value='description'/>">
  </a>
<s:form  action="revenuebetweendate" namespace="/Administration/Revenue" theme="simple"> 
                    <div id="sl12">      
                        <p>Start Date: <s:textfield name="startDate"/>    
                        </p>   
                    </div> 
                    <div id="sl12">
                        <p>End Date: <s:textfield name="endDate"/></p>         
                    </div>
                    <s:submit id="getrevenuedate"  value="Get report" cssStyle="width: 100px; margin-left: 12px; background-color: gray;" theme="simple" title="Get Report by Time"/>  
                </s:form>
<s:url action="kpUpload" namespace="/Administration/Bidding" var="kpUploadUrl"/>
<s:url action="MarkovUpload" namespace="/Administration/Bidding" var="mkUploadUrl"/>
<s:url namespace="/Administration/Staff" action="administrator" var="administratorUrl"></s:url>
<s:url namespace="/Administration/Customer" action="customer-management" var="customerUrl"></s:url>
<s:url namespace="/Administration/Product" action="product-management" var="producrUrl"></s:url>
<s:url namespace="/Administration/Catelogue" action="catelogue-management" var="catelogueUrl"></s:url>
<s:url namespace="/Administration/Supplier" action="supplier-management" var="supplierUrl"></s:url>
<s:url namespace="/Administration/Receipt" action="receip-management" var="receipUrl"></s:url>
<s:url namespace="/Administration/Order" action="order-management" var="orderUrl"></s:url>
<s:url namespace="/Administration/Inventory" action="inventory" var="inventoryUrl"></s:url>
<s:url namespace="/Administration/ExportExcel" action="ProductForm" var="exportUrl"></s:url>
<s:url action="salepage" var="salepageUrl"></s:url>

<ul>
    <li><s:a href="%{salepageUrl}">Sale Page</s:a></li>

    <li><a href="/Configuration"/>Configuration</a>
        <ul>
            <li><s:a href="%{administratorUrl}">Administrator</s:a></li>
            <li><a href="#">System history</a></li> 
            <li><a href="#">Backup data</a></li> 
        </ul>
    </li>


    <li><a href="/Management">Management</a>
        <ul>

            <li><s:a href="%{customerUrl}">Customer</s:a></li>

            <li><s:a href="%{administratorUrl}">Staff</s:a></li>

            <li><s:a href="%{supplierUrl}">Supplier</s:a></li>
        
            <li><s:a href="%{catelogueUrl}">Category</s:a></li>

            <li><s:a href="%{producrUrl}">Product</s:a></li>
     
        </ul>
    </li>
    <li><a href="#">Store</a>
        <ul>
            <li><s:a href="%{orderUrl}">Order</s:a></li>
        
            <li><s:a href="%{receipUrl}">Receipting</s:a></li>
        
            <li><a href="">Issuing</a></li>
        
            <li><s:a href="%{inventoryUrl}">Inventory</s:a></li>
        </ul>
    </li>
    <li><a href="#">Utilities</a>
        <ul>
            <li><a href="#">Stocktaking</a></li>
            <li><s:a href="%{exportUrl}">Excel Exporting</s:a></li>
        </ul>
    </li>
    <li><a href="">Tools</a>
        <ul>
            <li><a href="#">Product History</a></li>

            <li><s:a href="%{kpUploadUrl}"  title="Upload .csv file">Online KP Algorithm</s:a></li>
            <li><s:a href="%{mkUploadUrl}" title="Upload .csv file">Markov Decision Process</s:a></li>

        </ul>
    </li>
    <li><a href="#">Instructions</a></li>
</ul>